<?php
class retrieve_frameit_admin extends retrieve_base{

	private $module_display_options 	= array(
	);

		/**
	* function produces abstract structure of modules db structure
	*
    * used to generate the table structure required abstract function that passes an abstract
	* representation of the desired table structure to the proper database module which will
	* interpet the abstract and convert it into a valid SQL Create table structure.
	*
	* @return Array list of abstract table definitions for this module
	*/
	function create_table(){
		$tables = array();
		/**
		* Table structure for table 'frameit'
		*/
		$fields = array(
			array("fi_identifier"		,"unsigned integer"			,"NOT NULL"	,"auto_increment","key"),
			array("fi_client"			,"unsigned integer"			,"NOT NULL"	,"default '0'","key"),
			array("fi_label"			,"varchar(255)"				,"NOT NULL"	,"default ''"),
			array("fi_creation_date"	,"datetime"					,"NOT NULL"	,"default '0000-00-00 00:00:00'"),
			array("fi_status"			,"unsigned integer"			,"NOT NULL"	,"default '0'"),
			array("fi_uri"				,"text"						,"NOT NULL"	,"default ''"),
			array("fi_menu"				,"unsigned integer"			,"NOT NULL"	,"default '0'","key"),
			array("fi_parameterfields"	,"text"						,"NOT NULL"	,"default ''"),
			array("fi_width"			,"unsigned integer"			,"NOT NULL"	,"default '0'"),
			array("fi_height"			,"unsigned integer"			,"NOT NULL"	,"default '0'"),
			array("fi_width_type"		,"unsigned integer"			,"NOT NULL"	,"default '0'"),
			array("fi_height_type"		,"unsigned integer"			,"NOT NULL"	,"default '0'"),
			array("fi_longdes"			,"text"						,"NOT NULL" ,"default ''"),
			array("fi_show_label"		,"unsigned small integer"	,"NOT NULL"	,"default '0'")
		);
		$primary ="fi_identifier";
		$tables[count($tables)] = array("frameit", $fields, $primary);
		return $tables;
	}
}
?>